﻿namespace Libraries.Repositories
{
    public class ProcedureConfiguration
    {
        public const string PagingAccountCourse = "web.sp_AccountCourse_Search_Paging";
        public const string Departments = "win.sp_Department_FetchAllForCreateTreeView";

        public const string AccountCertificateSearch = "web.sp_AccountCertificate_Search";
        public const string Certificates = "web.sp_CertificateCategory_FetchAll";
		
		public const string PagingLanguageScore = "web.sp_LanguageScore_Search_Paging";
        public const string LanguageScoreHistory = "web.sp_LanguageScore_History";
        public const string FetchLanguageScoreByLanguageType = "web.sp_LanguageScore_FetchByLanguageType_Paging";
        public const string FetchAllLanguageType = "web.sp_LanguageType_FetchAll";
        public const string ListAllStatusAccount = "web.sp_StatusAccount_FetchAll";
        public const string ListAllDepartment = "web.sp_Department_FetchAll";
        public const string GetLanguageScoreById = "web.sp_LanguageScore_Details";
		public const string ListAllDepartmentPaging = "web.sp_Department_FetchAll_Paging";
		
		public const string PagingAccount = "web.sp_Account_Search_Paging";
        public const string GetAccountDetailsById = "web.sp_Account_GetAccountByEmployeeId";
        public const string GetAccountImage = "web.sp_AccountFileUpload_LoadImage";
        public const string GetEmployeeSkills = "web.sp_Account_GetEmployeeSkill";
        public const string GetAccountCertificates = "web.sp_AccountCertificate_FetchByEmployeeId";
        public const string GetLanguageScoreHistoryByEmployeeId = "web.sp_LanguageScore_HistoryByEmployeeId";
        public const string FetchAllContractType = "web.sp_ContractType_FetchAll";
        public const string FetchAllLocation = "web.sp_Location_FetchAll";
        public const string FetchAllJobTitle = "web.sp_JobTitle_FetchAll";
		
		public const string FetchAllArticle = "web.sp_Article_FetchAll";
        public const string FetchArticleById = "web.sp_Article_FetchById";
        public const string UpdateArticle = "web.sp_Article_Update";
        public const string AddArticle = "web.sp_Article_Addnew";

        public const string AccountCertificateRefund = "web.sp_Account_CertificateRefunds";
        public const string AccountCourseRefund = "web.sp_Account_CourseRefunds";
        public const string CourseInstructorFetchByInstructorId = "web.sp_CourseInstructor_FetchAllByInstructorId";
        public const string CertificateDetailByCertificateId = "web.sp_Certificate_DetailByCertificateId";
        public const string HistoryLanguageScoreByTypeAndEmployeeId = "web.sp_LanguageScore_HistoryByType";

        public const string CheckRole = "sp_Check_Role";
		
		
		#region Course
        public const string GetAllCoursePage = "[web].[sp_Course_FetchAll_Page]";
        public const string GetAllCoursePageByCategoryId = "[web].[sp_Course_FetchByCourseCategoryId_Paging]";
        public const string SearchCoursePageByCategoryId = "[web].[sp_Course_SearchCourse_Paging]";
        public const string CourseDetailsByCourseId = "[web].[sp_Course_FindByCourseId]";
        // public const string SearchEmployeeByCategoryIdPaging = "[web].[sp_Search_AllEmployee_By_CourseId_Paging]";



        public const string SearchEmployeeByCategoryId = "[web].[sp_Search_AllEmployee_By_CourseId]";

        public const string CourseCategoryFetchAllName = "[web].[sp_CourseCategory_FetchAllName]";
        public const string CourseCategorySearchPaging = "[web].[sp_CourseCategory_Search_Paging]";

        public const string FeedbackCourseFetchByCourseId = "[web].[sp_FeedbackCourse_FetchByCourseId]";


        public const string SearchCourseInstructorByCourseId = "[web].[sp_Search_CourseInstructor_By_CourseId]";
		#endregion
    }
}
